﻿<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="BlueENG.ascx.cs" Inherits="StreetSmartAdmin.BlueENG" %>
<h2>Blue NRG Form</h2>

            <asp:DetailsView ID="DetailsView5" runat="Server" CellPadding="4" ForeColor="#333333"
                        GridLines="None" DataSourceID="SqlDataSource35" AllowPaging="True" AutoGenerateRows="False"
                        DataKeyNames="ID" AutoGenerateInsertButton="True" DefaultMode="Edit" CssClass="mGrid"
                        PagerStyle-CssClass="pgr" AlternatingRowStyle-CssClass="alt" 
                            EnableModelValidation="True">
                <AlternatingRowStyle CssClass="alt" />
                <Fields>
                    <asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False" 
                        ReadOnly="True" SortExpression="ID" />
                    <asp:BoundField DataField="UserID" HeaderText="UserID" 
                        SortExpression="UserID" />
                    <asp:BoundField DataField="sales_cust_number" HeaderText="sales_cust_number" 
                        SortExpression="sales_cust_number" />
                    <asp:BoundField DataField="customer_type" HeaderText="customer_type" 
                        SortExpression="customer_type" />
                    <asp:BoundField DataField="product_type_code" HeaderText="product_type_code" 
                        SortExpression="product_type_code" />
                    <asp:BoundField DataField="voice_ver_extn" HeaderText="voice_ver_extn" 
                        SortExpression="voice_ver_extn" />
                    <asp:BoundField DataField="voice_ver_date" HeaderText="voice_ver_date" 
                        SortExpression="voice_ver_date" />
                    <asp:BoundField DataField="sales_name" HeaderText="sales_name" 
                        SortExpression="sales_name" />
                    <asp:BoundField DataField="acct_mgr_name" HeaderText="acct_mgr_name" 
                        SortExpression="acct_mgr_name" />
                    <asp:BoundField DataField="first_name" HeaderText="first_name" 
                        SortExpression="first_name" />
                    <asp:BoundField DataField="last_name" HeaderText="last_name" 
                        SortExpression="last_name" />
                    <asp:BoundField DataField="initials" HeaderText="initials" 
                        SortExpression="initials" />
                    <asp:BoundField DataField="party_name" HeaderText="party_name" 
                        SortExpression="party_name" />
                    <asp:BoundField DataField="company_type" HeaderText="company_type" 
                        SortExpression="company_type" />
                    <asp:BoundField DataField="industry_type" HeaderText="industry_type" 
                        SortExpression="industry_type" />
                    <asp:BoundField DataField="acn_number" HeaderText="acn_number" 
                        SortExpression="acn_number" />
                    <asp:BoundField DataField="abn_number" HeaderText="abn_number" 
                        SortExpression="abn_number" />
                    <asp:BoundField DataField="site_identifier" HeaderText="site_identifier" 
                        SortExpression="site_identifier" />
                    <asp:BoundField DataField="site_addr_unit_type" 
                        HeaderText="site_addr_unit_type" SortExpression="site_addr_unit_type" />
                    <asp:BoundField DataField="site_addr_unit_no" HeaderText="site_addr_unit_no" 
                        SortExpression="site_addr_unit_no" />
                    <asp:BoundField DataField="site_addr_floor_type" 
                        HeaderText="site_addr_floor_type" SortExpression="site_addr_floor_type" />
                    <asp:BoundField DataField="site_addr_floor_no" HeaderText="site_addr_floor_no" 
                        SortExpression="site_addr_floor_no" />
                    <asp:BoundField DataField="site_addr_street_no" 
                        HeaderText="site_addr_street_no" SortExpression="site_addr_street_no" />
                    <asp:BoundField DataField="site_streetno_suffix" 
                        HeaderText="site_streetno_suffix" SortExpression="site_streetno_suffix" />
                    <asp:BoundField DataField="site_addr_street_name" 
                        HeaderText="site_addr_street_name" SortExpression="site_addr_street_name" />
                    <asp:BoundField DataField="stype_code" HeaderText="stype_code" 
                        SortExpression="stype_code" />
                    <asp:BoundField DataField="site_addr_suburb" HeaderText="site_addr_suburb" 
                        SortExpression="site_addr_suburb" />
                    <asp:BoundField DataField="site_addr_city" HeaderText="site_addr_city" 
                        SortExpression="site_addr_city" />
                    <asp:BoundField DataField="spost_code" HeaderText="spost_code" 
                        SortExpression="spost_code" />
                    <asp:BoundField DataField="site_addr_property_name" 
                        HeaderText="site_addr_property_name" SortExpression="site_addr_property_name" />
                    <asp:BoundField DataField="site_addr_location_desc" 
                        HeaderText="site_addr_location_desc" SortExpression="site_addr_location_desc" />
                    <asp:BoundField DataField="site_hazard_desc" HeaderText="site_hazard_desc" 
                        SortExpression="site_hazard_desc" />
                    <asp:BoundField DataField="site_access_details" 
                        HeaderText="site_access_details" SortExpression="site_access_details" />
                    <asp:BoundField DataField="cust_postal_addr_1" HeaderText="cust_postal_addr_1" 
                        SortExpression="cust_postal_addr_1" />
                    <asp:BoundField DataField="cust_postal_addr_2" HeaderText="cust_postal_addr_2" 
                        SortExpression="cust_postal_addr_2" />
                    <asp:BoundField DataField="cust_postal_addr_3" HeaderText="cust_postal_addr_3" 
                        SortExpression="cust_postal_addr_3" />
                    <asp:BoundField DataField="cust_postal_code" HeaderText="cust_postal_code" 
                        SortExpression="cust_postal_code" />
                    <asp:BoundField DataField="cust_street_addr_1" HeaderText="cust_street_addr_1" 
                        SortExpression="cust_street_addr_1" />
                    <asp:BoundField DataField="cust_street_addr_2" HeaderText="cust_street_addr_2" 
                        SortExpression="cust_street_addr_2" />
                    <asp:BoundField DataField="cust_street_addr_3" HeaderText="cust_street_addr_3" 
                        SortExpression="cust_street_addr_3" />
                    <asp:BoundField DataField="cust_dpid_number" HeaderText="cust_dpid_number" 
                        SortExpression="cust_dpid_number" />
                    <asp:BoundField DataField="cust_dpid_barcode" HeaderText="cust_dpid_barcode" 
                        SortExpression="cust_dpid_barcode" />
                    <asp:BoundField DataField="prop_type" HeaderText="prop_type" 
                        SortExpression="prop_type" />
                    <asp:BoundField DataField="cust_income_source" HeaderText="cust_income_source" 
                        SortExpression="cust_income_source" />
                    <asp:BoundField DataField="cust_notes" HeaderText="cust_notes" 
                        SortExpression="cust_notes" />
                    <asp:BoundField DataField="std_code" HeaderText="std_code" 
                        SortExpression="std_code" />
                    <asp:BoundField DataField="cust_phone_no" HeaderText="cust_phone_no" 
                        SortExpression="cust_phone_no" />
                    <asp:BoundField DataField="cust_fax_no" HeaderText="cust_fax_no" 
                        SortExpression="cust_fax_no" />
                    <asp:BoundField DataField="cust_email_addr" HeaderText="cust_email_addr" 
                        SortExpression="cust_email_addr" />
                    <asp:BoundField DataField="cust_web_addr" HeaderText="cust_web_addr" 
                        SortExpression="cust_web_addr" />
                    <asp:BoundField DataField="cust_employer" HeaderText="cust_employer" 
                        SortExpression="cust_employer" />
                    <asp:BoundField DataField="cust_emp_ph_no" HeaderText="cust_emp_ph_no" 
                        SortExpression="cust_emp_ph_no" />
                    <asp:BoundField DataField="dob" HeaderText="dob" SortExpression="dob" />
                    <asp:BoundField DataField="contact_first_name" HeaderText="contact_first_name" 
                        SortExpression="contact_first_name" />
                    <asp:BoundField DataField="contact_last_name" HeaderText="contact_last_name" 
                        SortExpression="contact_last_name" />
                    <asp:BoundField DataField="initials1" HeaderText="initials1" 
                        SortExpression="initials1" />
                    <asp:BoundField DataField="contact_addr_ln1" HeaderText="contact_addr_ln1" 
                        SortExpression="contact_addr_ln1" />
                    <asp:BoundField DataField="contact_addr_ln2" HeaderText="contact_addr_ln2" 
                        SortExpression="contact_addr_ln2" />
                    <asp:BoundField DataField="contact_addr_ln3" HeaderText="contact_addr_ln3" 
                        SortExpression="contact_addr_ln3" />
                    <asp:BoundField DataField="contact_job_title" HeaderText="contact_job_title" 
                        SortExpression="contact_job_title" />
                    <asp:BoundField DataField="contact_work_ph" HeaderText="contact_work_ph" 
                        SortExpression="contact_work_ph" />
                    <asp:BoundField DataField="contact_work_fax" HeaderText="contact_work_fax" 
                        SortExpression="contact_work_fax" />
                    <asp:BoundField DataField="contact_home_ph" HeaderText="contact_home_ph" 
                        SortExpression="contact_home_ph" />
                    <asp:BoundField DataField="contact_mobile_ph" HeaderText="contact_mobile_ph" 
                        SortExpression="contact_mobile_ph" />
                    <asp:BoundField DataField="contact_email" HeaderText="contact_email" 
                        SortExpression="contact_email" />
                    <asp:BoundField DataField="customer_dlicense" HeaderText="customer_dlicense" 
                        SortExpression="customer_dlicense" />
                    <asp:BoundField DataField="dlicense_exp_date" HeaderText="dlicense_exp_date" 
                        SortExpression="dlicense_exp_date" />
                    <asp:BoundField DataField="customer_passport" HeaderText="customer_passport" 
                        SortExpression="customer_passport" />
                    <asp:BoundField DataField="passport_exp_date" HeaderText="passport_exp_date" 
                        SortExpression="passport_exp_date" />
                    <asp:BoundField DataField="bill_cycle_code" HeaderText="bill_cycle_code" 
                        SortExpression="bill_cycle_code" />
                    <asp:BoundField DataField="delivery_method_code" 
                        HeaderText="delivery_method_code" SortExpression="delivery_method_code" />
                    <asp:BoundField DataField="pull_bill_custom_dir" 
                        HeaderText="pull_bill_custom_dir" SortExpression="pull_bill_custom_dir" />
                    <asp:BoundField DataField="pull_bill_date" HeaderText="pull_bill_date" 
                        SortExpression="pull_bill_date" />
                    <asp:BoundField DataField="previous_supplier_code" 
                        HeaderText="previous_supplier_code" SortExpression="previous_supplier_code" />
                    <asp:BoundField DataField="avg_monthly_spend" HeaderText="avg_monthly_spend" 
                        SortExpression="avg_monthly_spend" />
                    <asp:BoundField DataField="usage_profile_code" HeaderText="usage_profile_code" 
                        SortExpression="usage_profile_code" />
                    <asp:BoundField DataField="netwk_code" HeaderText="netwk_code" 
                        SortExpression="netwk_code" />
                    <asp:BoundField DataField="tco_code" HeaderText="tco_code" 
                        SortExpression="tco_code" />
                    <asp:BoundField DataField="term_code" HeaderText="term_code" 
                        SortExpression="term_code" />
                    <asp:BoundField DataField="contract_date" HeaderText="contract_date" 
                        SortExpression="contract_date" />
                    <asp:BoundField DataField="conc_start_date" HeaderText="conc_start_date" 
                        SortExpression="conc_start_date" />
                    <asp:BoundField DataField="conc_end_date" HeaderText="conc_end_date" 
                        SortExpression="conc_end_date" />
                    <asp:BoundField DataField="card_type" HeaderText="card_type" 
                        SortExpression="card_type" />
                    <asp:BoundField DataField="conc_card_number" HeaderText="conc_card_number" 
                        SortExpression="conc_card_number" />
                    <asp:BoundField DataField="conc_card_code" HeaderText="conc_card_code" 
                        SortExpression="conc_card_code" />
                    <asp:BoundField DataField="conc_card_exp_date" HeaderText="conc_card_exp_date" 
                        SortExpression="conc_card_exp_date" />
                    <asp:BoundField DataField="customer_salutation" 
                        HeaderText="customer_salutation" SortExpression="customer_salutation" />
                    <asp:BoundField DataField="transfer_type" HeaderText="transfer_type" 
                        SortExpression="transfer_type" />
                    <asp:BoundField DataField="customer_payment_method" 
                        HeaderText="customer_payment_method" SortExpression="customer_payment_method" />
                    <asp:BoundField DataField="customer_dd_bank" HeaderText="customer_dd_bank" 
                        SortExpression="customer_dd_bank" />
                    <asp:BoundField DataField="customer_dd_branch" HeaderText="customer_dd_branch" 
                        SortExpression="customer_dd_branch" />
                    <asp:BoundField DataField="customer_dd_number" HeaderText="customer_dd_number" 
                        SortExpression="customer_dd_number" />
                    <asp:BoundField DataField="customer_cc_type" HeaderText="customer_cc_type" 
                        SortExpression="customer_cc_type" />
                    <asp:BoundField DataField="customer_cc_name" HeaderText="customer_cc_name" 
                        SortExpression="customer_cc_name" />
                    <asp:BoundField DataField="customer_cc_number" HeaderText="customer_cc_number" 
                        SortExpression="customer_cc_number" />
                    <asp:BoundField DataField="customer_cc_expiry_dt" 
                        HeaderText="customer_cc_expiry_dt" SortExpression="customer_cc_expiry_dt" />
                    <asp:BoundField DataField="customer_cc_verify_no" 
                        HeaderText="customer_cc_verify_no" SortExpression="customer_cc_verify_no" />
                    <asp:BoundField DataField="site_addr_street_suffix" 
                        HeaderText="site_addr_street_suffix" SortExpression="site_addr_street_suffix" />
                    <asp:BoundField DataField="life_support_machine_type" 
                        HeaderText="life_support_machine_type" 
                        SortExpression="life_support_machine_type" />
                    <asp:BoundField DataField="rate_card_code" HeaderText="rate_card_code" 
                        SortExpression="rate_card_code" />
                    <asp:BoundField DataField="campaign_name" HeaderText="campaign_name" 
                        SortExpression="campaign_name" />
                    <asp:BoundField DataField="incentive_code" HeaderText="incentive_code" 
                        SortExpression="incentive_code" />
                    <asp:BoundField DataField="termination_fee_code" 
                        HeaderText="termination_fee_code" SortExpression="termination_fee_code" />
                    <asp:BoundField DataField="est_ann_kwhs" HeaderText="est_ann_kwhs" 
                        SortExpression="est_ann_kwhs" />
                    <asp:BoundField DataField="password" HeaderText="password" 
                        SortExpression="password" />
                    <asp:BoundField DataField="sales_internal_tariff" 
                        HeaderText="sales_internal_tariff" SortExpression="sales_internal_tariff" />
                    <asp:BoundField DataField="green_percent" HeaderText="green_percent" 
                        SortExpression="green_percent" />
                    <asp:BoundField DataField="meter_num" HeaderText="meter_num" 
                        SortExpression="meter_num" />
                    <asp:BoundField DataField="g_code" HeaderText="g_code" 
                        SortExpression="g_code" />
                    <asp:BoundField DataField="lot_number" HeaderText="lot_number" 
                        SortExpression="lot_number" />
                    <asp:BoundField DataField="identifier" HeaderText="identifier" 
                        SortExpression="identifier" />
                    <asp:BoundField DataField="trading_name" HeaderText="trading_name" 
                        SortExpression="trading_name" />
                    <asp:BoundField DataField="trustee_name" HeaderText="trustee_name" 
                        SortExpression="trustee_name" />
                    <asp:BoundField DataField="rate_card_version" HeaderText="rate_card_version" 
                        SortExpression="rate_card_version" />
                    <asp:BoundField DataField="green_type" HeaderText="green_type" 
                        SortExpression="green_type" />
                    <asp:BoundField DataField="proposed_move_in_date" 
                        HeaderText="proposed_move_in_date" SortExpression="proposed_move_in_date" />
                    <asp:BoundField DataField="special_instructions" 
                        HeaderText="special_instructions" SortExpression="special_instructions" />
                    <asp:BoundField DataField="cgc" HeaderText="cgc" SortExpression="cgc" />
                    <asp:BoundField DataField="Consolidated_group_NMI" 
                        HeaderText="Consolidated_group_NMI" SortExpression="Consolidated_group_NMI" />
                    <asp:BoundField DataField="Base_commission" HeaderText="Base_commission" 
                        SortExpression="Base_commission" />
                    <asp:CommandField ShowEditButton="True" />
                </Fields>
                <PagerStyle CssClass="pgr" />
            </asp:DetailsView>

                                <asp:SqlDataSource ID="SqlDataSource35" runat="server" 
                            ConnectionString='<%$ ConnectionStrings:SQLServer2005DBConnectionString %>' 
                            DeleteCommand="DELETE FROM [Blue_NRG] WHERE [ID] = @ID" 
                            InsertCommand="INSERT INTO [Blue_NRG] ([UserID], [sales_cust_number], [customer_type], [product_type_code], [voice_ver_extn], [voice_ver_date], [sales_name], [acct_mgr_name], [first_name], [last_name], [initials], [party_name], [company_type], [industry_type], [acn_number], [abn_number], [site_identifier], [site_addr_unit_type], [site_addr_unit_no], [site_addr_floor_type], [site_addr_floor_no], [site_addr_street_no], [site_streetno_suffix], [site_addr_street_name], [stype_code], [site_addr_suburb], [site_addr_city], [spost_code], [site_addr_property_name], [site_addr_location_desc], [site_hazard_desc], [site_access_details], [cust_postal_addr_1], [cust_postal_addr_2], [cust_postal_addr_3], [cust_postal_code], [cust_street_addr_1], [cust_street_addr_2], [cust_street_addr_3], [cust_dpid_number], [cust_dpid_barcode], [prop_type], [cust_income_source], [cust_notes], [std_code], [cust_phone_no], [cust_fax_no], [cust_email_addr], [cust_web_addr], [cust_employer], [cust_emp_ph_no], [dob], [contact_first_name], [contact_last_name], [initials1], [contact_addr_ln1], [contact_addr_ln2], [contact_addr_ln3], [contact_job_title], [contact_work_ph], [contact_work_fax], [contact_home_ph], [contact_mobile_ph], [contact_email], [customer_dlicense], [dlicense_exp_date], [customer_passport], [passport_exp_date], [bill_cycle_code], [delivery_method_code], [pull_bill_custom_dir], [pull_bill_date], [previous_supplier_code], [avg_monthly_spend], [usage_profile_code], [netwk_code], [tco_code], [term_code], [contract_date], [conc_start_date], [conc_end_date], [card_type], [conc_card_number], [conc_card_code], [conc_card_exp_date], [customer_salutation], [transfer_type], [customer_payment_method], [customer_dd_bank], [customer_dd_branch], [customer_dd_number], [customer_cc_type], [customer_cc_name], [customer_cc_number], [customer_cc_expiry_dt], [customer_cc_verify_no], [medicard_no], [site_addr_street_suffix], [life_support_machine_type], [rate_card_code], [campaign_name], [incentive_code], [termination_fee_code], [est_ann_kwhs], [password], [sales_internal_tariff], [green_percent], [meter_num], [g_code], [lot_number], [identifier], [trading_name], [trustee_name], [rate_card_version], [green_type], [proposed_move_in_date], [special_instructions], [cgc], [Consolidated_group_NMI], [Base_commission]) VALUES (@UserID, @sales_cust_number, @customer_type, @product_type_code, @voice_ver_extn, @voice_ver_date, @sales_name, @acct_mgr_name, @first_name, @last_name, @initials, @party_name, @company_type, @industry_type, @acn_number, @abn_number, @site_identifier, @site_addr_unit_type, @site_addr_unit_no, @site_addr_floor_type, @site_addr_floor_no, @site_addr_street_no, @site_streetno_suffix, @site_addr_street_name, @stype_code, @site_addr_suburb, @site_addr_city, @spost_code, @site_addr_property_name, @site_addr_location_desc, @site_hazard_desc, @site_access_details, @cust_postal_addr_1, @cust_postal_addr_2, @cust_postal_addr_3, @cust_postal_code, @cust_street_addr_1, @cust_street_addr_2, @cust_street_addr_3, @cust_dpid_number, @cust_dpid_barcode, @prop_type, @cust_income_source, @cust_notes, @std_code, @cust_phone_no, @cust_fax_no, @cust_email_addr, @cust_web_addr, @cust_employer, @cust_emp_ph_no, @dob, @contact_first_name, @contact_last_name, @initials1, @contact_addr_ln1, @contact_addr_ln2, @contact_addr_ln3, @contact_job_title, @contact_work_ph, @contact_work_fax, @contact_home_ph, @contact_mobile_ph, @contact_email, @customer_dlicense, @dlicense_exp_date, @customer_passport, @passport_exp_date, @bill_cycle_code, @delivery_method_code, @pull_bill_custom_dir, @pull_bill_date, @previous_supplier_code, @avg_monthly_spend, @usage_profile_code, @netwk_code, @tco_code, @term_code, @contract_date, @conc_start_date, @conc_end_date, @card_type, @conc_card_number, @conc_card_code, @conc_card_exp_date, @customer_salutation, @transfer_type, @customer_payment_method, @customer_dd_bank, @customer_dd_branch, @customer_dd_number, @customer_cc_type, @customer_cc_name, @customer_cc_number, @customer_cc_expiry_dt, @customer_cc_verify_no, @medicard_no, @site_addr_street_suffix, @life_support_machine_type, @rate_card_code, @campaign_name, @incentive_code, @termination_fee_code, @est_ann_kwhs, @password, @sales_internal_tariff, @green_percent, @meter_num, @g_code, @lot_number, @identifier, @trading_name, @trustee_name, @rate_card_version, @green_type, @proposed_move_in_date, @special_instructions, @cgc, @Consolidated_group_NMI, @Base_commission)" 
                            ProviderName="System.Data.SqlClient" SelectCommand="SELECT * FROM [Blue_NRG]" UpdateCommand="UPDATE [Blue_NRG] SET [UserID] = @UserID, [sales_cust_number] = @sales_cust_number, [customer_type] = @customer_type, [product_type_code] = @product_type_code, [voice_ver_extn] = @voice_ver_extn, [voice_ver_date] = @voice_ver_date, [sales_name] = @sales_name, [acct_mgr_name] = @acct_mgr_name, [first_name] = @first_name, [last_name] = @last_name, [initials] = @initials, [party_name] = @party_name, [company_type] = @company_type, [industry_type] = @industry_type, [acn_number] = @acn_number, [abn_number] = @abn_number, [site_identifier] = @site_identifier, [site_addr_unit_type] = @site_addr_unit_type, [site_addr_unit_no] = @site_addr_unit_no, [site_addr_floor_type] = @site_addr_floor_type, [site_addr_floor_no] = @site_addr_floor_no, [site_addr_street_no] = @site_addr_street_no, [site_streetno_suffix] = @site_streetno_suffix, [site_addr_street_name] = @site_addr_street_name, [stype_code] = @stype_code, [site_addr_suburb] = @site_addr_suburb, [site_addr_city] = @site_addr_city, [spost_code] = @spost_code, [site_addr_property_name] = @site_addr_property_name, [site_addr_location_desc] = @site_addr_location_desc, [site_hazard_desc] = @site_hazard_desc, [site_access_details] = @site_access_details, [cust_postal_addr_1] = @cust_postal_addr_1, [cust_postal_addr_2] = @cust_postal_addr_2, [cust_postal_addr_3] = @cust_postal_addr_3, [cust_postal_code] = @cust_postal_code, [cust_street_addr_1] = @cust_street_addr_1, [cust_street_addr_2] = @cust_street_addr_2, [cust_street_addr_3] = @cust_street_addr_3, [cust_dpid_number] = @cust_dpid_number, [cust_dpid_barcode] = @cust_dpid_barcode, [prop_type] = @prop_type, [cust_income_source] = @cust_income_source, [cust_notes] = @cust_notes, [std_code] = @std_code, [cust_phone_no] = @cust_phone_no, [cust_fax_no] = @cust_fax_no, [cust_email_addr] = @cust_email_addr, [cust_web_addr] = @cust_web_addr, [cust_employer] = @cust_employer, [cust_emp_ph_no] = @cust_emp_ph_no, [dob] = @dob, [contact_first_name] = @contact_first_name, [contact_last_name] = @contact_last_name, [initials1] = @initials1, [contact_addr_ln1] = @contact_addr_ln1, [contact_addr_ln2] = @contact_addr_ln2, [contact_addr_ln3] = @contact_addr_ln3, [contact_job_title] = @contact_job_title, [contact_work_ph] = @contact_work_ph, [contact_work_fax] = @contact_work_fax, [contact_home_ph] = @contact_home_ph, [contact_mobile_ph] = @contact_mobile_ph, [contact_email] = @contact_email, [customer_dlicense] = @customer_dlicense, [dlicense_exp_date] = @dlicense_exp_date, [customer_passport] = @customer_passport, [passport_exp_date] = @passport_exp_date, [bill_cycle_code] = @bill_cycle_code, [delivery_method_code] = @delivery_method_code, [pull_bill_custom_dir] = @pull_bill_custom_dir, [pull_bill_date] = @pull_bill_date, [previous_supplier_code] = @previous_supplier_code, [avg_monthly_spend] = @avg_monthly_spend, [usage_profile_code] = @usage_profile_code, [netwk_code] = @netwk_code, [tco_code] = @tco_code, [term_code] = @term_code, [contract_date] = @contract_date, [conc_start_date] = @conc_start_date, [conc_end_date] = @conc_end_date, [card_type] = @card_type, [conc_card_number] = @conc_card_number, [conc_card_code] = @conc_card_code, [conc_card_exp_date] = @conc_card_exp_date, [customer_salutation] = @customer_salutation, [transfer_type] = @transfer_type, [customer_payment_method] = @customer_payment_method, [customer_dd_bank] = @customer_dd_bank, [customer_dd_branch] = @customer_dd_branch, [customer_dd_number] = @customer_dd_number, [customer_cc_type] = @customer_cc_type, [customer_cc_name] = @customer_cc_name, [customer_cc_number] = @customer_cc_number, [customer_cc_expiry_dt] = @customer_cc_expiry_dt, [customer_cc_verify_no] = @customer_cc_verify_no, [medicard_no] = @medicard_no, [site_addr_street_suffix] = @site_addr_street_suffix, [life_support_machine_type] = @life_support_machine_type, [rate_card_code] = @rate_card_code, [campaign_name] = @campaign_name, [incentive_code] = @incentive_code, [termination_fee_code] = @termination_fee_code, [est_ann_kwhs] = @est_ann_kwhs, [password] = @password, [sales_internal_tariff] = @sales_internal_tariff, [green_percent] = @green_percent, [meter_num] = @meter_num, [g_code] = @g_code, [lot_number] = @lot_number, [identifier] = @identifier, [trading_name] = @trading_name, [trustee_name] = @trustee_name, [rate_card_version] = @rate_card_version, [green_type] = @green_type, [proposed_move_in_date] = @proposed_move_in_date, [special_instructions] = @special_instructions, [cgc] = @cgc, [Consolidated_group_NMI] = @Consolidated_group_NMI, [Base_commission] = @Base_commission WHERE [ID] = @ID"
                    >
                        <DeleteParameters>
                            <asp:Parameter Name="ID" Type="Int32" />
                        </DeleteParameters>
                        <InsertParameters>
                            <asp:Parameter Name="UserID" Type="Int32" />
                            <asp:Parameter Name="sales_cust_number" Type="Int32" />
                            <asp:Parameter Name="customer_type" Type="String" />
                            <asp:Parameter Name="product_type_code" Type="String" />
                            <asp:Parameter Name="voice_ver_extn" Type="String" />
                            <asp:Parameter Name="voice_ver_date" Type="String" />
                            <asp:Parameter Name="sales_name" Type="String" />
                            <asp:Parameter Name="acct_mgr_name" Type="String" />
                            <asp:Parameter Name="first_name" Type="String" />
                            <asp:Parameter Name="last_name" Type="String" />
                            <asp:Parameter Name="initials" Type="String" />
                            <asp:Parameter Name="party_name" Type="String" />
                            <asp:Parameter Name="company_type" Type="String" />
                            <asp:Parameter Name="industry_type" Type="String" />
                            <asp:Parameter Name="acn_number" Type="String" />
                            <asp:Parameter Name="abn_number" Type="String" />
                            <asp:Parameter Name="site_identifier" Type="String" />
                            <asp:Parameter Name="site_addr_unit_type" Type="String" />
                            <asp:Parameter Name="site_addr_unit_no" Type="String" />
                            <asp:Parameter Name="site_addr_floor_type" Type="String" />
                            <asp:Parameter Name="site_addr_floor_no" Type="String" />
                            <asp:Parameter Name="site_addr_street_no" Type="String" />
                            <asp:Parameter Name="site_streetno_suffix" Type="String" />
                            <asp:Parameter Name="site_addr_street_name" Type="String" />
                            <asp:Parameter Name="stype_code" Type="String" />
                            <asp:Parameter Name="site_addr_suburb" Type="String" />
                            <asp:Parameter Name="site_addr_city" Type="String" />
                            <asp:Parameter Name="spost_code" Type="String" />
                            <asp:Parameter Name="site_addr_property_name" Type="String" />
                            <asp:Parameter Name="site_addr_location_desc" Type="String" />
                            <asp:Parameter Name="site_hazard_desc" Type="String" />
                            <asp:Parameter Name="site_access_details" Type="String" />
                            <asp:Parameter Name="cust_postal_addr_1" Type="String" />
                            <asp:Parameter Name="cust_postal_addr_2" Type="String" />
                            <asp:Parameter Name="cust_postal_addr_3" Type="String" />
                            <asp:Parameter Name="cust_postal_code" Type="String" />
                            <asp:Parameter Name="cust_street_addr_1" Type="String" />
                            <asp:Parameter Name="cust_street_addr_2" Type="String" />
                            <asp:Parameter Name="cust_street_addr_3" Type="String" />
                            <asp:Parameter Name="cust_dpid_number" Type="String" />
                            <asp:Parameter Name="cust_dpid_barcode" Type="String" />
                            <asp:Parameter Name="prop_type" Type="String" />
                            <asp:Parameter Name="cust_income_source" Type="String" />
                            <asp:Parameter Name="cust_notes" Type="String" />
                            <asp:Parameter Name="std_code" Type="String" />
                            <asp:Parameter Name="cust_phone_no" Type="String" />
                            <asp:Parameter Name="cust_fax_no" Type="String" />
                            <asp:Parameter Name="cust_email_addr" Type="String" />
                            <asp:Parameter Name="cust_web_addr" Type="String" />
                            <asp:Parameter Name="cust_employer" Type="String" />
                            <asp:Parameter Name="cust_emp_ph_no" Type="String" />
                            <asp:Parameter Name="dob" Type="String" />
                            <asp:Parameter Name="contact_first_name" Type="String" />
                            <asp:Parameter Name="contact_last_name" Type="String" />
                            <asp:Parameter Name="initials1" Type="String" />
                            <asp:Parameter Name="contact_addr_ln1" Type="String" />
                            <asp:Parameter Name="contact_addr_ln2" Type="String" />
                            <asp:Parameter Name="contact_addr_ln3" Type="String" />
                            <asp:Parameter Name="contact_job_title" Type="String" />
                            <asp:Parameter Name="contact_work_ph" Type="String" />
                            <asp:Parameter Name="contact_work_fax" Type="String" />
                            <asp:Parameter Name="contact_home_ph" Type="String" />
                            <asp:Parameter Name="contact_mobile_ph" Type="String" />
                            <asp:Parameter Name="contact_email" Type="String" />
                            <asp:Parameter Name="customer_dlicense" Type="String" />
                            <asp:Parameter Name="dlicense_exp_date" Type="String" />
                            <asp:Parameter Name="customer_passport" Type="String" />
                            <asp:Parameter Name="passport_exp_date" Type="String" />
                            <asp:Parameter Name="bill_cycle_code" Type="String" />
                            <asp:Parameter Name="delivery_method_code" Type="String" />
                            <asp:Parameter Name="pull_bill_custom_dir" Type="String" />
                            <asp:Parameter Name="pull_bill_date" Type="String" />
                            <asp:Parameter Name="previous_supplier_code" Type="String" />
                            <asp:Parameter Name="avg_monthly_spend" Type="String" />
                            <asp:Parameter Name="usage_profile_code" Type="String" />
                            <asp:Parameter Name="netwk_code" Type="String" />
                            <asp:Parameter Name="tco_code" Type="String" />
                            <asp:Parameter Name="term_code" Type="String" />
                            <asp:Parameter Name="contract_date" Type="String" />
                            <asp:Parameter Name="conc_start_date" Type="String" />
                            <asp:Parameter Name="conc_end_date" Type="String" />
                            <asp:Parameter Name="card_type" Type="String" />
                            <asp:Parameter Name="conc_card_number" Type="String" />
                            <asp:Parameter Name="conc_card_code" Type="String" />
                            <asp:Parameter Name="conc_card_exp_date" Type="String" />
                            <asp:Parameter Name="customer_salutation" Type="String" />
                            <asp:Parameter Name="transfer_type" Type="String" />
                            <asp:Parameter Name="customer_payment_method" Type="String" />
                            <asp:Parameter Name="customer_dd_bank" Type="String" />
                            <asp:Parameter Name="customer_dd_branch" Type="String" />
                            <asp:Parameter Name="customer_dd_number" Type="String" />
                            <asp:Parameter Name="customer_cc_type" Type="String" />
                            <asp:Parameter Name="customer_cc_name" Type="String" />
                            <asp:Parameter Name="customer_cc_number" Type="String" />
                            <asp:Parameter Name="customer_cc_expiry_dt" Type="String" />
                            <asp:Parameter Name="customer_cc_verify_no" Type="String" />
                            <asp:Parameter Name="medicard_no" Type="String" />
                            <asp:Parameter Name="site_addr_street_suffix" Type="String" />
                            <asp:Parameter Name="life_support_machine_type" Type="String" />
                            <asp:Parameter Name="rate_card_code" Type="String" />
                            <asp:Parameter Name="campaign_name" Type="String" />
                            <asp:Parameter Name="incentive_code" Type="String" />
                            <asp:Parameter Name="termination_fee_code" Type="String" />
                            <asp:Parameter Name="est_ann_kwhs" Type="String" />
                            <asp:Parameter Name="password" Type="String" />
                            <asp:Parameter Name="sales_internal_tariff" Type="String" />
                            <asp:Parameter Name="green_percent" Type="String" />
                            <asp:Parameter Name="meter_num" Type="String" />
                            <asp:Parameter Name="g_code" Type="String" />
                            <asp:Parameter Name="lot_number" Type="String" />
                            <asp:Parameter Name="identifier" Type="String" />
                            <asp:Parameter Name="trading_name" Type="String" />
                            <asp:Parameter Name="trustee_name" Type="String" />
                            <asp:Parameter Name="rate_card_version" Type="String" />
                            <asp:Parameter Name="green_type" Type="String" />
                            <asp:Parameter Name="proposed_move_in_date" Type="String" />
                            <asp:Parameter Name="special_instructions" Type="String" />
                            <asp:Parameter Name="cgc" Type="String" />
                            <asp:Parameter Name="Consolidated_group_NMI" Type="String" />
                            <asp:Parameter Name="Base_commission" Type="String" />
                        </InsertParameters>
                        <UpdateParameters>
                            <asp:Parameter Name="UserID" Type="Int32" />
                            <asp:Parameter Name="sales_cust_number" Type="Int32" />
                            <asp:Parameter Name="customer_type" Type="String" />
                            <asp:Parameter Name="product_type_code" Type="String" />
                            <asp:Parameter Name="voice_ver_extn" Type="String" />
                            <asp:Parameter Name="voice_ver_date" Type="String" />
                            <asp:Parameter Name="sales_name" Type="String" />
                            <asp:Parameter Name="acct_mgr_name" Type="String" />
                            <asp:Parameter Name="first_name" Type="String" />
                            <asp:Parameter Name="last_name" Type="String" />
                            <asp:Parameter Name="initials" Type="String" />
                            <asp:Parameter Name="party_name" Type="String" />
                            <asp:Parameter Name="company_type" Type="String" />
                            <asp:Parameter Name="industry_type" Type="String" />
                            <asp:Parameter Name="acn_number" Type="String" />
                            <asp:Parameter Name="abn_number" Type="String" />
                            <asp:Parameter Name="site_identifier" Type="String" />
                            <asp:Parameter Name="site_addr_unit_type" Type="String" />
                            <asp:Parameter Name="site_addr_unit_no" Type="String" />
                            <asp:Parameter Name="site_addr_floor_type" Type="String" />
                            <asp:Parameter Name="site_addr_floor_no" Type="String" />
                            <asp:Parameter Name="site_addr_street_no" Type="String" />
                            <asp:Parameter Name="site_streetno_suffix" Type="String" />
                            <asp:Parameter Name="site_addr_street_name" Type="String" />
                            <asp:Parameter Name="stype_code" Type="String" />
                            <asp:Parameter Name="site_addr_suburb" Type="String" />
                            <asp:Parameter Name="site_addr_city" Type="String" />
                            <asp:Parameter Name="spost_code" Type="String" />
                            <asp:Parameter Name="site_addr_property_name" Type="String" />
                            <asp:Parameter Name="site_addr_location_desc" Type="String" />
                            <asp:Parameter Name="site_hazard_desc" Type="String" />
                            <asp:Parameter Name="site_access_details" Type="String" />
                            <asp:Parameter Name="cust_postal_addr_1" Type="String" />
                            <asp:Parameter Name="cust_postal_addr_2" Type="String" />
                            <asp:Parameter Name="cust_postal_addr_3" Type="String" />
                            <asp:Parameter Name="cust_postal_code" Type="String" />
                            <asp:Parameter Name="cust_street_addr_1" Type="String" />
                            <asp:Parameter Name="cust_street_addr_2" Type="String" />
                            <asp:Parameter Name="cust_street_addr_3" Type="String" />
                            <asp:Parameter Name="cust_dpid_number" Type="String" />
                            <asp:Parameter Name="cust_dpid_barcode" Type="String" />
                            <asp:Parameter Name="prop_type" Type="String" />
                            <asp:Parameter Name="cust_income_source" Type="String" />
                            <asp:Parameter Name="cust_notes" Type="String" />
                            <asp:Parameter Name="std_code" Type="String" />
                            <asp:Parameter Name="cust_phone_no" Type="String" />
                            <asp:Parameter Name="cust_fax_no" Type="String" />
                            <asp:Parameter Name="cust_email_addr" Type="String" />
                            <asp:Parameter Name="cust_web_addr" Type="String" />
                            <asp:Parameter Name="cust_employer" Type="String" />
                            <asp:Parameter Name="cust_emp_ph_no" Type="String" />
                            <asp:Parameter Name="dob" Type="String" />
                            <asp:Parameter Name="contact_first_name" Type="String" />
                            <asp:Parameter Name="contact_last_name" Type="String" />
                            <asp:Parameter Name="initials1" Type="String" />
                            <asp:Parameter Name="contact_addr_ln1" Type="String" />
                            <asp:Parameter Name="contact_addr_ln2" Type="String" />
                            <asp:Parameter Name="contact_addr_ln3" Type="String" />
                            <asp:Parameter Name="contact_job_title" Type="String" />
                            <asp:Parameter Name="contact_work_ph" Type="String" />
                            <asp:Parameter Name="contact_work_fax" Type="String" />
                            <asp:Parameter Name="contact_home_ph" Type="String" />
                            <asp:Parameter Name="contact_mobile_ph" Type="String" />
                            <asp:Parameter Name="contact_email" Type="String" />
                            <asp:Parameter Name="customer_dlicense" Type="String" />
                            <asp:Parameter Name="dlicense_exp_date" Type="String" />
                            <asp:Parameter Name="customer_passport" Type="String" />
                            <asp:Parameter Name="passport_exp_date" Type="String" />
                            <asp:Parameter Name="bill_cycle_code" Type="String" />
                            <asp:Parameter Name="delivery_method_code" Type="String" />
                            <asp:Parameter Name="pull_bill_custom_dir" Type="String" />
                            <asp:Parameter Name="pull_bill_date" Type="String" />
                            <asp:Parameter Name="previous_supplier_code" Type="String" />
                            <asp:Parameter Name="avg_monthly_spend" Type="String" />
                            <asp:Parameter Name="usage_profile_code" Type="String" />
                            <asp:Parameter Name="netwk_code" Type="String" />
                            <asp:Parameter Name="tco_code" Type="String" />
                            <asp:Parameter Name="term_code" Type="String" />
                            <asp:Parameter Name="contract_date" Type="String" />
                            <asp:Parameter Name="conc_start_date" Type="String" />
                            <asp:Parameter Name="conc_end_date" Type="String" />
                            <asp:Parameter Name="card_type" Type="String" />
                            <asp:Parameter Name="conc_card_number" Type="String" />
                            <asp:Parameter Name="conc_card_code" Type="String" />
                            <asp:Parameter Name="conc_card_exp_date" Type="String" />
                            <asp:Parameter Name="customer_salutation" Type="String" />
                            <asp:Parameter Name="transfer_type" Type="String" />
                            <asp:Parameter Name="customer_payment_method" Type="String" />
                            <asp:Parameter Name="customer_dd_bank" Type="String" />
                            <asp:Parameter Name="customer_dd_branch" Type="String" />
                            <asp:Parameter Name="customer_dd_number" Type="String" />
                            <asp:Parameter Name="customer_cc_type" Type="String" />
                            <asp:Parameter Name="customer_cc_name" Type="String" />
                            <asp:Parameter Name="customer_cc_number" Type="String" />
                            <asp:Parameter Name="customer_cc_expiry_dt" Type="String" />
                            <asp:Parameter Name="customer_cc_verify_no" Type="String" />
                            <asp:Parameter Name="medicard_no" Type="String" />
                            <asp:Parameter Name="site_addr_street_suffix" Type="String" />
                            <asp:Parameter Name="life_support_machine_type" Type="String" />
                            <asp:Parameter Name="rate_card_code" Type="String" />
                            <asp:Parameter Name="campaign_name" Type="String" />
                            <asp:Parameter Name="incentive_code" Type="String" />
                            <asp:Parameter Name="termination_fee_code" Type="String" />
                            <asp:Parameter Name="est_ann_kwhs" Type="String" />
                            <asp:Parameter Name="password" Type="String" />
                            <asp:Parameter Name="sales_internal_tariff" Type="String" />
                            <asp:Parameter Name="green_percent" Type="String" />
                            <asp:Parameter Name="meter_num" Type="String" />
                            <asp:Parameter Name="g_code" Type="String" />
                            <asp:Parameter Name="lot_number" Type="String" />
                            <asp:Parameter Name="identifier" Type="String" />
                            <asp:Parameter Name="trading_name" Type="String" />
                            <asp:Parameter Name="trustee_name" Type="String" />
                            <asp:Parameter Name="rate_card_version" Type="String" />
                            <asp:Parameter Name="green_type" Type="String" />
                            <asp:Parameter Name="proposed_move_in_date" Type="String" />
                            <asp:Parameter Name="special_instructions" Type="String" />
                            <asp:Parameter Name="cgc" Type="String" />
                            <asp:Parameter Name="Consolidated_group_NMI" Type="String" />
                            <asp:Parameter Name="Base_commission" Type="String" />
                            <asp:Parameter Name="ID" Type="Int32" />
                        </UpdateParameters>
                    </asp:SqlDataSource>